package com.example.finalassignment.mapper;

import com.example.finalassignment.pojo.UserInfo;
import org.apache.ibatis.annotations.Param;

/**
* @author guocheng
* @description 针对表【user_info(用户详细信息表)】的数据库操作Mapper
* @createDate 2024-05-16 21:28:54
* @Entity com.example.finalassignment.pojo.UserInfo
*/
public interface UserInfoMapper {

    int deleteByPrimaryKey(Long id);

    int insert(UserInfo record);

    int insertSelective(UserInfo record);

    UserInfo selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(UserInfo record);

    int updateByPrimaryKey(UserInfo record);

    UserInfo selectByUserId(@Param("userId") String userId);

    /**
     * 根据邮箱查询数据
     */
    UserInfo selectByMailbox(@Param("mailbox") String mailbox);

    /**
     * 根据user_id 改头像
     */
    int updatePicture(@Param("picture") String picture,@Param("userId") String userId);
}
